//
//  BuildJLRZViewController.m
//  Estate
//
//  Created by heyong on 2016/10/17.
//  Copyright © 2016年 ttsx. All rights reserved.
//

#import "BuildJLRZViewController.h"
#define DIC_EXPANDED @"expanded" //是否是展开 0收缩 1展开
#define DIC_ARARRY @"array"
#define DIC_TITILESTRING @"title"
#define CELL_HEIGHT 46.0f
#import "RJTableCell.h"
#import "JLJLTableCell.h"

#import "ZJRZViewController_Detail.h"
@interface BuildJLRZViewController ()

@end

@implementation BuildJLRZViewController

- (NSMutableArray *)dataArray{
    
    if(_dataArray==nil){
        _dataArray=[NSMutableArray array];
    }
    return _dataArray;
}

-(UITableView *)tableView{
    
    if(_tableView==nil){
        _tableView=[[UITableView alloc]initWithFrame:CGRectMake(0, 0, DEF_SCREEN_WIDTH, DEF_SCREEN_HEIGHT-44-49-50*BIZ)];
        _tableView.delegate=self;
        _tableView.dataSource=self;
        [_tableView registerNib:[UINib nibWithNibName:@"RJTableCell" bundle:nil] forCellReuseIdentifier:@"RJCell"];
        [_tableView registerNib:[UINib nibWithNibName:@"JLJLTableCell" bundle:nil] forCellReuseIdentifier:@"JLJLCell"];
    }
    return _tableView;
}

- (void)viewDidLoad {
    [super viewDidLoad];
    
    [self.view addSubview:self.tableView];
    self.tableView.tableFooterView=[[UIView alloc]initWithFrame:CGRectZero];
    self.view.backgroundColor=[UIColor colorWithRed:0.97 green:0.97 blue:0.97 alpha:1.00];
    self.tableView.backgroundColor=[UIColor colorWithRed:0.97 green:0.97 blue:0.97 alpha:1.00];
    [self initDataSource];
    NSNotificationCenter * center = [NSNotificationCenter defaultCenter];
    [center addObserver:self selector:@selector(refresh:) name:@"Refresh_zj_rz" object:nil];
}


- (void)refresh:(id)sender{
    [self.dataArray removeAllObjects];
    [self initDataSource];
    [self.tableView reloadData];
}

//初始化数据
- (void)initDataSource
{
    FMDatabase *db=[FMDatabase databaseWithPath:DEF_DB_DATABASEPATH];
    
    [db open];
    FMResultSet *result=[db executeQuery:
                         SQL_WORKLOGJ_JFRZ_SELECT(PROID)];
    
    NSMutableDictionary *dic;
    
    while ([result next]) {
        //查询到 年
        NSString* year= [result stringForColumn:@"year"];
        //查询到月
        NSString *month =[LSUtility deletaeZero:[result stringForColumn:@"month"]] ;
        
        //展开页查询条件
        NSString *condition=[result stringForColumn:@"condition"];
        
        /*
         * 根据日期查询展开的数据
         */
        NSString *sqlStr=[NSString stringWithFormat:@"SELECT substr(CREATE_TIME,1,10) AS Day,* FROM WORK_LOG WHERE substr(CREATE_TIME,1,7) = '%@'  AND PRO_ID='%@' and LOG_TYPE='LOG_01' ORDER BY CREATE_TIME desc ",
                          condition,
                          DEF_PERSISTENT_GET_OBJECT(@"proid")];
        
        
        FMResultSet *results=[db executeQuery:sqlStr];
        //查询到记录
        NSMutableArray *DetailArr=[NSMutableArray array];
        
        while ([results next]) {
            //id
            NSString *ids=[results stringForColumn:@"ID"];
            //判断是日志类型
            NSString *type=[results stringForColumn:@"LOG_TYPE"];
            //获得天
            NSString *day=[results stringForColumn:@"Day"];
            
            //标题
            NSString *title;
            if([type isEqualToString:@"LOG_01"]){
                title =[NSString stringWithFormat:@"%@项目监理日志",day];
            }else if([type isEqualToString:@"LOG_02"]){
                title =[NSString stringWithFormat:@"%@项目安全日志",day];
            }
            
            //时间
            NSString *time=[results stringForColumn:@"CREATE_TIME"];
           
            //创建人
            NSString *createName=[results stringForColumn:@"Create_User_name"];
            
            if([createName isEqualToString:@"admin"]){
            createName=@"admin";
            }else{
                createName=[LSUtility getuserNameByRealName:createName][@"REAL_NAME"];
            }
            //状态
            int staint=[results intForColumn:@"REVIEW_STATE"];
            NSString *state=staint==0?@"待审阅":@"已审阅";
            
            //记录人
            //            NSString *logUserId=[results stringForColumn:@"LOG_USERS"];
            NSString *recordName=DEF_PERSISTENT_GET_OBJECT(@"realname");
            NSDictionary *dict=@{@"id":ids,@"title":title,@"time":time,@"state":state,@"recordName":DEFISNUL(recordName) ,@"createName":DEFISNUL(createName),@"type":type};
            
            [DetailArr addObject:dict];
        }
        
        //查询到数量
        NSString *count=[result stringForColumn:@"count"];
        //拼接成标题
        NSString *tiemAndCount=[NSString stringWithFormat:@"%@年%@月(%@条)",year,month,count];
        
        //创建一个字典 包含数组，分组名，是否展开的标示
        dic=[[NSMutableDictionary alloc] initWithObjectsAndKeys:DetailArr,DIC_ARARRY,tiemAndCount,DIC_TITILESTRING,[NSNumber numberWithInt:0],DIC_EXPANDED,nil];
        //将字典加入数组
        [self.dataArray addObject:dic];
    }
    
    [db close];
    
}

#pragma mark - Table view data source

- (NSInteger)numberOfSectionsInTableView:(UITableView *)tableView {
    return _dataArray.count;
}

- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section {
    NSMutableDictionary *dic=[_dataArray objectAtIndex:section];
    NSArray *array=[dic objectForKey:DIC_ARARRY];
    //判断是收缩还是展开
    if ([[dic objectForKey:DIC_EXPANDED]intValue]) {
        return array.count;
    }else{
        return 0;
    }
    
}

- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath{
    long section=indexPath.section;
    long row=indexPath.row;
    //得到改组下信息
    NSMutableDictionary *dic=[self.dataArray objectAtIndex:section];
    NSArray *array=[dic objectForKey:DIC_ARARRY];
    NSDictionary *dataD=array[row];
    
    RJTableCell *cell=[tableView dequeueReusableCellWithIdentifier:@"RJCell" forIndexPath:indexPath];
    cell.title.text=[dataD objectForKey:@"title"];
    cell.name.text=[dataD objectForKey:@"createName"];
    cell.time.text=[dataD objectForKey:@"time"];
    [cell setType:[dataD objectForKey:@"state"]];
    
    return cell;
}

//设置分组头的视图
- (UIView *)tableView:(UITableView *)tableView viewForHeaderInSection:(NSInteger)section
{
    UIView *hView = [[UIView alloc]initWithFrame:CGRectMake(0,0, DEF_SCREEN_WIDTH, CELL_HEIGHT-10)];
    hView.backgroundColor=[UIColor colorWithRed:0.94 green:0.94 blue:0.94 alpha:1.00];
    UIButton* eButton = [[UIButton alloc] init];
    eButton.backgroundColor=[UIColor whiteColor];
    //按钮填充整个视图
    eButton.frame = hView.frame;
    [eButton addTarget:self action:@selector(expandButtonClicked:) forControlEvents:UIControlEventTouchUpInside];
    //把节号保存到按钮tag，以便传递到expandButtonClicked方法
    eButton.tag = section;
    //根据是否展开，切换按钮显示图片
    if ([self isExpanded:section])
        [eButton setImage:  [UIImage imageNamed: @"xiala" ]forState:UIControlStateNormal];
    else
        [eButton setImage: [UIImage imageNamed: @"gengduo1" ]forState:UIControlStateNormal];
    
    //设置分组标题
    [eButton setTitle:[[_dataArray objectAtIndex:section] objectForKey:DIC_TITILESTRING]forState:UIControlStateNormal];
    
    [eButton setTitleColor:[UIColor colorWithRed:0.68 green:0.68 blue:0.68 alpha:1.00] forState:UIControlStateNormal];
    //设置字体样式
    eButton.titleLabel.font=[UIFont systemFontOfSize:14.*BIZ];
    
    //设置button的图片和标题的相对位置
    
    //4个参数是到上边界，左边界，下边界，右边界的距离
    eButton.contentHorizontalAlignment =UIControlContentHorizontalAlignmentLeft;
    [eButton setTitleEdgeInsets:UIEdgeInsetsMake(0,5, 0,0)];
    [eButton setImageEdgeInsets:UIEdgeInsetsMake(0,DEF_SCREEN_WIDTH-30, 0,0)];
    
    //添加btn
    [hView addSubview: eButton];
    return hView;
    
}
- (CGFloat)tableView:(UITableView *)tableView heightForFooterInSection:(NSInteger)section{
    //判断是收缩还是展开
    NSMutableDictionary *dic=[_dataArray objectAtIndex:section];
    if ([[dic objectForKey:DIC_EXPANDED]intValue]) {
        return 10;
    }else{
        return 0;
    }
}

//控制表头分组表头高度
- (CGFloat)tableView:(UITableView *)tableView heightForHeaderInSection:(NSInteger)section
{
    return 46*BIZ;
}

- (CGFloat)tableView:(UITableView *)tableView heightForRowAtIndexPath:(NSIndexPath *)indexPath{
    return 70*BIZ;
}

#pragma mark-点击表格
- (void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath{
    long section=indexPath.section;
    long row=indexPath.row;
    //得到改组下信息
    NSMutableDictionary *dic=[self.dataArray objectAtIndex:section];
    NSArray *array=[dic objectForKey:DIC_ARARRY];
    NSDictionary *dataD=array[row];
    
    ZJRZViewController_Detail *detail=[[ZJRZViewController_Detail alloc]init];
    detail.jiafangQuery=@"jia";

    detail.logId=dataD[@"id"];
    detail.type=dataD[@"type"];
    
    detail.state=@"";
    [self.navigationController pushViewController:detail animated:YES];
    
}

#pragma mark -- 内部调用

//对指定的节进行“展开/折叠”操作,若原来是折叠的则展开，若原来是展开的则折叠
-(void)collapseOrExpand:(long)section{
    NSMutableDictionary *dic=[_dataArray objectAtIndex:section];
    int expanded=[[dic objectForKey:DIC_EXPANDED] intValue];
    if (expanded) {
        [dic setValue:[NSNumber numberWithInt:0]forKey:DIC_EXPANDED];
    }else
    {
        [dic setValue:[NSNumber numberWithInt:1]forKey:DIC_EXPANDED];
    }
    
}

//返回指定节是否是展开的

-(int)isExpanded:(long)section{
    NSDictionary *dic=[_dataArray objectAtIndex:section];
    int expanded=[[dic objectForKey:DIC_EXPANDED] intValue];
    return expanded;
}

//按钮被点击时触发
-(void)expandButtonClicked:(id)sender{
    UIButton* btn= (UIButton*)sender;
    long section= btn.tag;//取得tag知道点击对应哪个块
    [self collapseOrExpand:section];
    //刷新tableview
    [self.tableView reloadData];
}

@end
